MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Role = 986

View and edit SQL

Suggested facets: Title, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
206493 22.38 0 0 333837 Drawings and Prints 11 Book 97 Authentic Memoirs of the Late George Morland, With Remarks on His Abilities and Progress as an Artist           Designer|Author|Publisher|Printer 986   George Morland|Francis William Blagdon|Edward Orme|Barnard and Sultzer British, London 1763–1804 London|British, baptised London 1777–1819|British, Manchester 1775–1848 London|London   Morland, George|Blagdon, Francis William|Orme, Edward|Barnard and Sultzer 17327 British|British|British|British 177 1763 |1775 |1775 |1800 1804 |1819 |1848 |1850 1806 1806 1806 Illustrations: etching 28943 17 13/16 x 22 5/16 x 7/8 in. (45.2 x 56.6 x 2.2cm) Rogers Fund, 1922                       Books 442   Metropolitan Museum of Art, New York, NY 1
231917 1978.570.2 0 0 359661 Drawings and Prints 11 Book 97 Les Jardins Prècieux         Collection Pierre Corrard chez Meynial 455 Designer|Author|Publisher|Printer 986 Designed by|Preface written by|Published by|Printed by Raymond Charmaison|Henri de Régnier|J. Meynial|Jean Saudé French, Paris 1898–1955 Paris|French, 1864–1936|French (Collection Pierre Corrard) Charmaison, Raymond|Régnier, Henri de|Meynial, J.|Saudé, Jean 31084 French|French|French 103 1898 |1864 1955 |1936 November 5, 1919 1919 1919 mechanical reproductions over-printed with pochoir 36666 Overall: 18 11/16 x 13 3/16 x 3/8 in. (47.5 x 33.5 x 1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1978                       Books 442   Metropolitan Museum of Art, New York, NY 1
231925 1986.1229.2 0 0 359669 Drawings and Prints 11 Book 97 Poèmes           Designer|Author|Publisher|Printer 986 Designed by|Written by|Published at the expense of|Printed by Nicolas de Staël|René Char|Nicolas de Staël|Fequet et Baudier (Marthe Fequet et Pierre Baudier) French, 1914–1955|French, born 1907|French, 1914–1955|French   Staël, Nicolas de|Char, René|Staël, Nicolas de|Fequet et Baudier (Marthe Fequet et Pierre Baudier) 31090 French|French|French|French 95 1914 |1907 |1914 1955 |2007 |1955 November 1952 1952 1952 Woodcut 26552 sheet: 14 9/16 x 11 1/4 in. (37 x 28.5 cm) Gift of Theodore Schempp, 1986                       Books 442   Metropolitan Museum of Art, New York, NY 1
231926 1986.1229.3 0 0 359670 Drawings and Prints 11 Book 97 Poèmes           Designer|Author|Publisher|Printer 986 Designed by|Written by|Published at the expense of|Printed by Nicolas de Staël|René Char|Nicolas de Staël|Fequet et Baudier (Marthe Fequet et Pierre Baudier) French, 1914–1955|French, born 1907|French, 1914–1955|French   Staël, Nicolas de|Char, René|Staël, Nicolas de|Fequet et Baudier (Marthe Fequet et Pierre Baudier) 31090 French|French|French|French 95 1914 |1907 |1914 1955 |2007 |1955 November 1952 1952 1952 Woodcut 26552 sheet: 14 9/16 x 11 1/4 in. (37 x 28.5 cm) Gift of Theodore Schempp, 1986                       Books 442   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 133.187ms · Data license: CC0 · Data source: metmuseum/openaccess